SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805710 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805710 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827807,1042355,45606,590531,338941,1024422,684263,960073,66386,211047,469368,377297,869567,111392,727346,438089,745696,40104,500225,5938,419311,285420,653919,411560,291830,806192,292596,821668,241291,831393,853867,435639,158560,8253,115975,699336,602766,86794,835579,832701,153749,432046,1039360,586015,885208,146434,452422,569795,40432,613309,850824,350791,456067,872696,256994,221218,438185,298767,121723,132878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]