SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910041 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910041 [ RunTime:0.002607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904805,347529,670799,1035964,366618,881371,658466,761657,486945,532244,192671,719817,876116,639524,237755,958155,409807,991149,108167,1011567,396842,597498,604475,990718,322712,359351,837015,430914,843408,251343,123286,30433,516187,469484,65271,187057,96786,21720,222722,310777,622903,192812,329872,947890,453577,86682,553712,224262,110010,892331,223813,683764,294647,848813,16015,754492,659378,664007,486499,61302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]