SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404082 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404082 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796246,136382,890465,777435,468807,421602,620718,340802,471648,475871,296512,865170,244570,704119,659393,400526,175520,1039438,835148,351921,786371,1044197,832133,86908,460232,572305,258019,556562,385410,61469,1021151,8043,97418,219175,596998,847018,747371,989939,1021234,327680,732781,1024839,733407,40367,169083,675508,677714,36555,988768,547055,786776,291155,1040668,279717,439681,105894,530871,858457,650443,973601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]