SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 138801 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 138801 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416674,309853,596447,623359,867243,285064,836990,996648,6389,940438,1040646,282865,554171,653680,663294,223830,470085,898883,889324,1047748,803220,239492,271017,402469,258394,59900,13486,296341,56373,164101,194691,759296,1016174,958025,15104,147752,788041,1014616,245056,532035,305902,738042,501373,786718,739635,774368,597979,506419,927837,443043,855258,572861,1010350,203888,124586,983442,763660,805281,955165,823762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 138801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 138801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]