SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550291 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550291 [ RunTime:0.002289s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240195,73687,303221,916473,560006,3858,201956,928551,280297,59022,348480,1016534,787055,995254,477391,987980,444672,773935,368144,913865,95598,364332,373717,869452,510099,48343,377410,942961,10463,288010,327047,940475,789509,265850,285997,370186,144104,546258,752556,148113,92780,922780,483154,57830,455713,209996,522069,409041,994452,409370,925420,293761,244560,207230,696998,713695,800690,297773,35984,536147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001448s ]