SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392008 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392008 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938442,168398,779443,836656,371151,37226,258084,578336,514801,511532,11555,78238,18303,513302,249687,603912,316231,393535,967170,546495,386251,642157,1006878,24923,785776,883369,174454,896894,230574,812330,90105,368458,531175,132622,872080,833398,758724,191548,5066,318693,216917,545220,501179,864156,43626,659727,45743,140155,959515,875302,518899,35425,78150,808274,1028568,777998,634870,116685,338546,171491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]