SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42695 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42695 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533521,320472,256750,589973,1002454,150906,209902,954480,735742,325243,537785,195480,754922,763249,162839,967042,366050,703176,778149,69582,533074,679311,437073,145226,501718,217245,835823,695027,851667,850687,517459,291113,977270,133564,9119,898164,908921,562533,627333,847278,186501,803722,345103,728345,25578,493600,756661,43902,544900,916998,522842,708510,478593,1008274,805503,909716,308331,325744,488823,508023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42695 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42695 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]