SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002037s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 90418 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 90418 [ RunTime:0.002127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722771,900080,413146,352650,967856,946975,945952,297983,7874,547467,516926,377412,1039186,774398,641798,429435,239958,93879,625428,72767,288633,679648,542074,870946,887159,272547,30475,507318,265739,609339,686085,179811,862577,26958,310836,944912,101382,216609,653311,507600,814597,77020,136914,731306,706101,49993,43732,800863,456305,647618,301198,539775,273390,49897,204989,401299,7506,641504,91514,510801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 90418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 90418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]