SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422151 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422151 [ RunTime:0.001023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433635,900320,435234,842457,934969,675520,180952,691401,890594,250417,661878,1033625,964681,683194,404280,253909,249923,279923,167485,630096,569399,563098,136512,33652,771424,9650,981512,261547,274496,256003,863976,90379,859872,386898,433991,44900,588518,992376,82294,456160,531314,742384,515724,1041547,1001955,169797,1042563,873369,453399,901592,599030,770143,942494,115854,794105,205451,894086,754374,219170,33812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]