SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198640 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198640 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896697,322670,415940,50854,964299,569321,16394,548156,615989,378603,60570,9270,510243,903512,416987,728988,502410,472966,187780,356634,317928,148541,9928,567570,199281,546106,296192,455592,100711,455480,916092,9913,835451,909796,211614,988574,430924,507304,286654,608615,478460,591626,304439,689360,1033396,992562,178981,9854,169509,493316,342583,417408,290983,547431,256350,924828,589599,368382,696289,168828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]