SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526091 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526091 [ RunTime:0.004829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365359,19173,412750,700112,689014,1038313,4257,584220,542892,968065,773712,799680,218538,105617,32038,955158,665180,310872,629514,787856,1032866,728626,923484,71113,444735,391906,870542,99931,729597,792701,293198,953188,747533,839267,784420,998797,492953,732573,45744,699103,953710,196113,662196,184000,683438,164221,47833,931038,3416,233734,361634,721969,1000233,530084,1014607,947353,205315,491882,875939,454336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002900s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003745s ]