SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447802 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447802 [ RunTime:0.004681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308183,897000,631011,329355,910601,224718,751574,325782,362123,586149,265196,620017,465184,229319,394318,559949,699205,864702,954237,770601,436450,696473,599543,567140,127795,1005215,34054,807993,175576,715950,845094,621141,952778,476605,782852,919791,820500,109986,414890,597746,696489,684300,970541,110848,980218,467299,703152,847797,1013991,408695,228627,684280,129596,669448,822131,397320,754692,127981,302798,728253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]