SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002554 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002554 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84578,313810,809111,924983,210811,1047868,867851,568960,447,233029,444391,927968,868293,514080,372668,789512,810405,540021,112178,193416,245774,714801,935421,807102,353970,820822,792219,269076,19449,445593,175722,11961,665051,553352,322303,893681,839303,383151,733191,694478,242625,44570,738614,488775,535455,559719,325424,8515,162855,1014294,94984,800253,969355,118446,691569,1031092,808509,267906,964526,135097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]