SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343535 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343535 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930315,971046,967255,672898,555347,191652,735936,543516,155054,826866,806522,388696,76257,168893,514240,683276,283591,401045,394873,413652,511114,587494,45253,184935,252526,506110,1001205,960008,282210,663255,924079,488550,16504,1026367,1000316,827700,12743,561410,691449,848008,94201,94082,342116,1026791,176662,393532,483276,448742,101609,1037079,981083,393792,181803,23741,640757,609322,235558,392405,841378,331183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001810s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]