SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558800 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558800 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155318,49594,56099,455557,965197,238349,337814,546690,997546,564855,1005852,597617,383009,18595,871489,303972,691971,231358,1000212,109778,85916,998564,846495,594462,912672,994892,726771,169072,251372,566716,277262,303318,1023703,571206,606956,90884,14850,304702,90821,395415,1001139,252060,131402,376090,423785,92414,916226,632774,753515,974904,61628,1006916,65619,101284,304473,316704,361779,257663,740058,580110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]