SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982464 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982464 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918080,233539,723817,814364,230886,1020628,403894,648008,681718,233807,1017760,800913,792046,84892,848448,265833,30227,136421,874814,93490,301435,535419,844411,697909,725595,31880,203413,344550,867116,1040833,919287,681427,407634,685980,530859,276794,278088,668213,349859,175258,73670,835277,196082,97881,221056,109644,952803,646691,608563,340034,70282,225236,413335,799240,329343,285553,354559,565587,426038,258255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982464 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982464 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]