SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38144 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38144 [ RunTime:0.003648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676838,339443,603336,7124,643255,48089,425004,339566,580967,644278,895133,892212,385919,251515,537657,309963,837410,384742,283332,239847,816534,972192,948723,885220,236333,741277,587028,351138,329075,42478,444397,139838,249905,979434,752615,110879,71138,113242,841911,581101,395754,317227,520267,905538,332854,925391,318595,1020752,882898,497002,98505,556948,847515,501116,1016894,879273,656990,172252,839749,650511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004504s ]