SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431800 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431800 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871554,679355,133788,787303,846547,782715,544299,709378,343116,375756,605826,822184,425727,1047152,251868,934912,182308,856674,594053,785932,268140,67694,260074,19605,875930,473035,621196,110984,13022,138236,197234,242343,849437,294727,568857,706877,404130,945169,954189,340609,634400,18347,276042,557437,291561,230400,597561,993007,7299,879516,448436,179900,100361,636909,1013981,920260,735087,178566,150584,1014547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]