SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28080 LIMIT 1 [ RunTime:0.004284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28080 [ RunTime:0.003324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387739,209844,229610,1046096,709283,337043,561351,205281,932760,927110,532211,171188,12754,909228,829005,597488,462374,40054,671083,252342,532858,1011902,75086,48510,900691,325752,25109,554881,479308,244673,544251,527697,570584,129061,624684,115858,1023445,700616,888682,330442,368317,484860,484626,916482,570347,258679,183375,68337,1006246,509474,401021,828680,332127,799638,456073,255899,1004791,181262,686742,726581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]