SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 270841 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 270841 [ RunTime:0.003905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407838,572180,1015992,644104,1032366,160959,565406,730615,280569,340808,600295,200338,936625,753773,831439,798547,442624,562599,521904,48767,915984,925754,364231,753328,800575,740813,603948,376063,126870,608416,402355,618357,774741,173148,796627,126073,81891,959379,677003,766227,655881,632982,300683,158652,682874,637466,201620,614313,5723,634724,237995,738034,528938,463508,68269,60363,142150,345918,51530,309291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 270841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 270841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]