SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001669s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28241 LIMIT 1 [ RunTime:0.001050s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28241 [ RunTime:0.004040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523790,403390,469241,71124,475828,1012726,420456,51973,788907,104689,460972,1021728,232467,806443,736236,896561,374528,174660,963771,978137,498346,930655,123955,275169,580166,191167,718007,725155,413937,674560,652952,236290,620106,631565,983408,983442,476410,953715,303373,576680,474192,729330,732838,800513,464381,230790,223773,238154,599103,27059,958375,703796,413328,392813,956341,631498,381264,572415,108485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]