SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442103 LIMIT 1 [ RunTime:0.000516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442103 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59248,83726,825817,252391,360082,362106,400180,915377,277747,837187,534136,537302,450560,945538,825161,1043078,853473,381149,638109,972014,77343,1008670,989918,111911,453557,606825,336718,230562,740676,608493,265919,638224,279652,812473,1027211,409963,369653,488763,546544,450085,274013,966621,89103,50285,98384,122925,169840,25945,363993,202413,217820,83171,762029,417588,491969,64348,781445,703915,498946,846061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]