SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475584 LIMIT 1 [ RunTime:0.003353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475584 [ RunTime:0.002390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322796,675379,214993,567118,906549,544591,861292,353565,316495,518041,772112,829680,338161,514842,1043116,978225,695911,552087,358565,212518,76683,162730,695366,758342,367487,170047,483997,258611,878892,479111,22019,260292,164581,843886,409217,482346,76711,347015,1046425,278966,87691,608672,401268,58276,977475,290450,4032,794484,259942,508592,380789,172795,123581,38942,741573,373542,26477,873040,471095,1035878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]