SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390523 LIMIT 1 [ RunTime:0.002240s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390523 [ RunTime:0.004005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661855,47629,1046037,156851,909944,252964,545582,727874,236146,776216,846161,862383,87004,499534,305336,369921,382996,94101,260137,705231,35272,868086,320188,883671,297223,879007,356015,188995,95412,994913,19385,841102,100019,507307,1004600,791511,239083,438593,220589,838388,979607,902378,1048298,846145,587022,956282,287623,885816,699346,787321,617376,163741,929664,362902,956532,446959,649499,824772,152180,15638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002130s ]