SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438894 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438894 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364432,84416,569375,18888,965750,242973,79595,300400,333703,20567,607796,532214,376166,353471,55067,573961,664866,416313,989325,271747,147179,106670,959323,451339,768270,638459,467007,629146,614848,512797,86968,822833,1000007,145999,445860,3637,750750,147946,1048020,890949,672807,961923,66336,434431,766467,739541,1031819,95649,16551,1006575,517648,150204,832828,693312,364923,675180,480351,690705,992333,582219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]