SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548002 LIMIT 1 [ RunTime:0.010060s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548002 [ RunTime:0.006284s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312083,61196,377428,117847,334886,546762,134098,919821,504215,569794,515421,368720,284988,316189,392921,605809,825622,412397,929638,194133,197750,36571,959782,502647,15817,646829,933676,647638,1032796,542876,115037,615124,939431,5974,569977,682264,32031,155672,664063,492452,694169,719703,517781,917925,697525,271916,237300,35974,989983,872030,72383,266055,519852,796617,25641,257871,323717,188368,179299,278369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002866s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000714s ]