SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549292 LIMIT 1 [ RunTime:0.000976s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549292 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67577,107692,367803,128507,830968,122336,921301,80402,278134,560236,479962,678688,115672,208353,617662,453279,1033018,590300,917962,741672,631790,361760,1021019,852713,488236,465083,96940,336470,189545,204452,742145,693107,931095,980528,541097,149122,717787,704373,613147,203149,569048,47766,718240,609694,505829,455265,112306,922207,902314,468440,145279,938113,503037,518072,961198,12613,658796,536624,36185,381973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]