SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 686910 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 686910 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106074,272473,394796,128365,92441,340090,812006,148764,417425,5585,74403,245094,932816,789996,162015,433194,247442,893355,721803,914561,499209,927587,620263,674575,920822,740163,269201,711310,141081,302893,1027767,1021035,831869,122006,1044261,774448,198811,660607,636250,24458,326682,144059,593275,919909,106331,785269,376845,38939,198727,1015373,334608,473913,70046,455723,412271,398980,794427,12767,994610,128532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 686910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 686910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]