SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343608 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343608 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122583,433120,387669,610912,611819,551821,488885,367108,537589,865196,1196,194168,833090,836972,648284,642322,627270,298994,618239,842158,1043623,810936,498643,771607,290660,497744,780387,774500,96168,293345,266998,332354,304897,376984,781098,75105,477642,500417,503996,582645,909929,638,109049,161672,797174,628274,281767,1020281,46981,175050,629688,671484,208884,522009,490568,453699,840922,456686,749725,1041103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]