SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047693 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047693 [ RunTime:0.004162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021758,919218,521124,961250,433185,398111,728923,294553,457581,123363,984192,425223,921764,489477,463840,855746,308826,579850,876762,763828,727615,903698,234791,910871,573477,688256,73473,525990,705779,632882,998323,763031,655756,190552,401957,866690,531445,303038,504148,374249,702707,757012,411784,492030,415910,5798,351623,7561,647692,1034474,149275,26819,503137,493275,675882,434040,62222,4664,1026614,859776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]