SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543880 LIMIT 1 [ RunTime:0.001301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543880 [ RunTime:0.002278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289099,321502,219532,608201,242035,31162,767534,595404,1037096,188975,176195,165791,41296,193978,742791,948284,412228,53735,556854,20253,779326,829639,16361,28125,258828,651110,791957,1024456,335047,271189,212958,212438,257544,39283,221954,490297,518194,490999,486504,606023,792373,523589,17364,1032494,388626,777204,1043096,92035,97288,294791,593023,290343,148916,60392,13905,599203,953934,1009252,547331,21610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]