SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442423 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442423 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105025,236245,478335,315395,153310,613042,684692,12873,1044770,260588,533155,904562,1020410,609380,1038212,558346,247381,668673,979007,70696,168594,667683,27518,1042609,146862,117043,545927,53018,820917,718087,193010,623977,934343,609229,840287,239198,294087,550756,778446,796231,5711,876012,41644,912143,53652,32447,143816,318042,721025,160487,383981,374446,1015889,39580,325375,12059,838625,128612,91090,400179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004342s ]