SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 769181 LIMIT 1 [ RunTime:0.001138s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 769181 [ RunTime:0.003650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854026,54212,587793,37975,483628,860867,221086,1018959,788375,113702,206111,493513,359070,156041,792512,405032,980639,561301,846623,531035,286192,612853,396211,668831,495922,826162,315450,1011489,194138,722848,1031350,927499,826350,640361,218075,471439,749633,45815,309449,385378,200538,513549,637115,266354,95643,284201,401248,779642,934742,575702,990113,185156,706687,1038014,896745,310342,237435,394901,271116,1026192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 769181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 769181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]