SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330418 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330418 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49543,985994,24340,529301,507929,32529,260560,1028163,1037215,245832,710573,470506,982572,647973,261671,410284,272075,644933,625847,639041,158336,696176,1048068,229393,771228,809219,684145,881920,224956,703590,293698,794155,421366,43971,80119,44695,742567,1021681,814695,662152,501798,772149,526928,241346,909142,868718,946815,753884,570011,611169,529611,1027358,572315,402655,1021719,951652,35412,1006713,933214,308334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]