SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503791 LIMIT 1 [ RunTime:0.002939s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503791 [ RunTime:0.005351s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291192,758634,411443,1006429,977351,2347,51051,199467,1041740,967148,192509,544470,888642,813881,220020,696750,568586,684419,913755,396732,651695,407489,335816,159781,1048166,522418,667614,365483,924295,184889,318032,248717,376152,722401,50588,199572,557779,290914,419995,13200,11623,37588,506750,47226,784659,563026,568958,241942,70664,406446,829216,255092,426636,766855,46706,752163,192953,373708,118463,796621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]