SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404105 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404105 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55799,517738,701052,774233,893743,722221,798086,416186,277820,391517,175355,1003765,718699,631880,265203,300008,695467,313788,614873,703909,967156,973813,752359,708709,1032970,79694,1002038,732590,861900,579740,406582,165928,169826,767826,1038928,747880,327386,403712,911920,1027875,662665,176703,721904,177927,46563,464701,320919,687973,560695,514779,992199,756614,978831,786104,403472,74302,964787,784930,198845,366075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000370s ]