SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320490 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320490 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128681,751692,627463,786247,414529,21145,1024957,431210,845167,122621,937706,165776,97565,456288,768937,1035605,1464,95998,613271,795774,691046,680971,950737,699384,693574,582006,269063,973172,816966,19104,832971,73016,1932,726949,740895,190290,888831,774296,667305,295938,1043334,716049,60213,277795,1045207,210697,650639,1012427,564768,414814,447912,438270,970246,410741,636708,513289,199584,374799,798205,18014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]