SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465911 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465911 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80526,604429,289560,560191,989291,552570,228258,427352,549256,577803,660912,155057,609328,844183,427743,770806,263879,888437,332469,530417,549232,653655,812588,106153,1008754,230702,988422,1013239,941922,260794,935980,98619,848995,776588,740699,449563,959415,844620,476208,562080,174162,183615,1015051,128269,480871,708979,949831,981576,806721,86950,522275,438957,732822,541867,975444,796775,917590,331027,371817,780453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001401s ]