SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809491 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809491 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280063,287132,566695,608515,572516,70571,1045880,162134,544259,930845,264740,551686,1036239,564008,971874,645070,898957,620914,328274,211385,825100,699859,288579,646918,563713,710217,478559,266667,664973,968472,475135,150428,667718,989964,142390,169482,731617,372341,880790,807495,352673,215700,600796,913499,101404,477335,923566,530189,139397,1022086,15145,451923,762734,190228,705423,615027,1033869,34819,99526,897667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002340s ]