SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 224201 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 224201 [ RunTime:0.002239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542905,107795,606096,183336,636180,1010380,711093,466749,364385,465813,511033,890413,138578,830215,320717,571181,368630,147840,653149,298986,814595,941807,324963,668444,481749,523011,603165,401078,836604,77799,920618,315251,680568,505681,291218,870300,392697,883350,58432,612394,737205,995510,976492,178459,546978,259338,426215,956194,187133,498647,498601,27019,661396,157706,911426,1045520,724325,629679,263634,682769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 224201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 224201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000880s ]