SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003585s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244904 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244904 [ RunTime:0.006840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197620,840437,195268,106424,660941,1010866,757590,221672,632778,1013536,104688,173610,533149,567186,977253,215224,838853,941713,546032,765001,791116,190159,884061,988964,722831,1022244,257276,231062,202604,374618,12775,638301,693246,389319,500142,727931,245996,1017370,992254,394859,421763,798989,507899,14236,671422,364008,292327,844315,498484,602719,75326,155372,240578,815757,192970,596164,987819,408393,688658,716730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]