SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522551 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522551 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016757,555539,183543,925834,957303,567742,368730,193890,370316,1034611,169985,300640,457900,885966,712477,1020612,260153,584171,510921,49041,901822,904014,388477,667912,477594,827046,653412,862931,468937,120343,993114,1037795,138595,299053,47381,592390,991503,716896,34819,524381,241405,434308,659606,346203,15157,100872,970614,387006,84956,52426,679835,684048,64884,329132,90044,1016094,792720,227439,715712,803694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]