SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508052 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508052 [ RunTime:0.002809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41512,82615,540868,375388,99189,986547,742707,705060,257803,882543,333700,895946,387350,929126,703767,794253,89593,791952,423047,625251,834048,508726,814987,118140,343040,411215,578202,23840,193602,214370,192435,343380,188905,1007461,423630,1006408,822711,201230,891562,47557,392718,330470,355763,775351,43162,156437,153925,708159,134874,736313,56863,301890,619441,501822,748699,685405,992886,578998,147891,202695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000762s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]