SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108354 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108354 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968200,164687,157479,24204,80380,32010,676443,525282,24569,709482,30767,75743,97308,256685,820094,829404,669932,87854,534974,780112,629748,149606,244377,590219,114591,6848,956958,677087,555006,552958,784663,749575,891777,672481,649092,916400,142102,404119,12230,625710,596476,583384,52317,924152,369948,297141,203853,637904,57803,489747,19736,389677,396527,601267,748007,116818,835492,535375,873065,546054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]