SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 915571 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 915571 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005217,198254,943078,626762,314292,896374,1047233,800655,967957,541723,171204,39074,59604,1005909,518547,296312,585421,873121,374821,187822,905987,463302,84613,265989,513048,212051,382190,799318,426926,29514,663780,121177,49072,89483,455099,20519,436073,545221,502251,365635,1004481,4986,480677,911987,37209,85446,127685,751872,99470,423668,386281,8434,299715,121721,885141,154233,708537,947611,503071,874053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 915571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 915571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]