SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38340 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38340 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402409,127736,676057,663219,232195,582100,933685,200457,754002,229320,252515,854618,749135,668149,889740,967301,934660,590206,723525,649984,953472,315334,208668,515476,970949,328276,202174,923426,1045550,534179,364977,217199,755099,418823,731388,778653,43056,554073,793601,546050,422204,574115,389132,474864,583452,450900,207625,392695,985004,981987,900005,57726,463843,78090,293524,652195,555427,886262,738530,345113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]