SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266531 LIMIT 1 [ RunTime:0.001140s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266531 [ RunTime:0.002616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (33042,815760,1005334,380875,209187,168306,576430,971808,334786,505431,503653,71598,790994,767364,173101,681938,549069,631472,877434,147927,407559,136463,37882,314146,83062,498421,382086,537333,627606,536681,863405,766375,311767,315598,493945,885631,499159,167044,333677,467212,411727,305626,688968,646304,245962,896302,1043585,1011259,418430,922889,640547,228958,606692,820237,560262,785755,979844,387909,134078,594820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]