SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431031 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431031 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940781,213442,800964,43779,182296,305737,929358,606250,422295,228747,924276,983217,619616,393968,561689,80285,408515,61113,702407,159727,213038,686185,124865,42358,910443,538478,79644,747664,105787,1003847,680931,847279,728107,521366,812364,372338,740699,338307,810486,473894,74990,332823,213748,88964,357900,125501,200550,896142,645029,978826,152300,324923,717130,461959,867281,912073,717536,1012721,32205,27319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]