SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546180 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546180 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740110,206903,74446,943127,950052,820112,49117,194039,302176,1040913,1012386,638943,315497,210138,375945,557326,748411,520040,1009554,1038640,133886,432656,264398,944402,128170,3123,357783,275949,1022234,338077,128297,697562,14053,837068,242769,667653,838801,948242,869676,411675,456150,170131,705696,161910,415991,101045,43984,109986,572560,873680,63093,523774,107247,768003,679800,361409,396533,890158,817464,780697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]