SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446198 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446198 [ RunTime:0.005094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62310,498364,225523,599206,712467,840782,453448,792780,438449,829170,1020660,100008,113350,301193,807700,834856,175953,302994,314,329333,665201,368141,10604,461183,153347,12658,373123,133111,985905,995951,690781,683923,113769,938878,432342,152729,1047895,50597,416857,685202,1027071,593248,561975,439090,888874,1036989,490592,699326,1004041,340730,229084,322933,641173,821655,97663,261383,993304,472370,17690,21970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]