SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464212 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464212 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925644,325773,962112,457879,93640,955249,419743,1047763,743941,587806,26604,452158,173906,667566,620722,549354,388507,170902,841421,397005,794860,571756,178136,535874,472590,176384,864624,813365,426664,1038479,64169,853956,454746,899779,269855,577684,734299,957010,272969,784309,836235,260660,318106,936470,128057,657348,110555,806470,952857,1040746,900116,831137,421703,509075,397615,679644,590542,191859,773669,442486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]