SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390983 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390983 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (73332,385997,96410,242148,207348,925915,551261,218527,405210,656676,109612,849011,305102,40849,728787,656173,26693,322902,158651,166074,11670,161119,359267,730962,512076,461241,24538,167010,917676,6936,384043,478927,398081,119123,728597,533638,80454,575811,695492,725814,618498,525793,650560,384882,892940,990718,956838,381572,606998,946564,918185,147622,458716,490854,416612,54311,979380,328193,829829,1014960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001763s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]