SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506464 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506464 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707114,978652,373016,68624,121524,60624,712650,210648,783472,473594,1013371,242224,987584,373416,713091,103780,750736,70254,529278,926469,647264,322380,754057,531207,864355,776881,458517,519061,528046,435221,230463,1004316,183969,352989,761719,113641,223674,256484,77899,470874,831028,375956,481842,257510,235079,325738,728447,917820,281108,7876,253915,34475,907898,574543,199778,957956,818624,772107,290865,219543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506464 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506464 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]