SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531896 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531896 [ RunTime:0.002781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413791,1046136,593402,69631,1010774,65962,748918,57528,1034010,764283,646154,463287,683379,714246,457969,167473,173080,319381,404591,70045,870930,529279,1036002,989252,338308,861847,370410,1002304,962107,78566,1016588,833192,989713,537893,562189,70434,160450,1009487,24718,798281,821424,171740,769076,758871,73148,640178,850527,819332,949282,844889,691506,207457,481685,897239,657344,873268,329379,672858,141007,496907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002253s ]