SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44527 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44527 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038061,169873,917691,138332,722966,220810,106755,716531,850994,48918,82568,641258,124734,300231,497055,10693,383770,930909,915877,518597,1004307,557211,135623,896431,59537,964459,282238,463264,887422,497250,620506,959215,542744,138963,286778,175849,693073,681695,833146,966461,724225,773308,796465,255680,657373,518898,311057,210935,605642,439204,300424,1006413,315871,116553,434662,47329,596942,366501,781440,137348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]