SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280534 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280534 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853520,793643,156325,247275,668137,931086,158727,189426,220042,164509,1014402,528838,840813,147824,220154,481342,984162,842801,584618,52750,31111,637277,187271,189716,520933,274014,24777,322646,553437,586563,306678,216000,245764,82349,509015,376450,991448,295340,33372,7183,209802,142200,1037996,484262,760292,928782,248919,817185,383458,589804,594830,927283,193209,888378,743581,360597,400239,327622,499036,427745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]