SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171818 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171818 [ RunTime:0.002861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919580,231068,32453,750420,391568,697668,615614,650177,117014,628581,235597,660862,37244,500070,26011,123460,878201,652664,11843,560008,584419,841233,962326,280737,158002,34293,417122,94005,230194,98684,63518,163714,729305,102864,989950,232530,567347,470435,1019405,966285,957026,246281,459546,501161,175768,381766,748361,109285,820540,5612,894495,114979,504902,840418,587056,564358,209660,755364,106414,349220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]