SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174581 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174581 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161151,112087,445477,407725,457587,111000,799275,123381,888088,791861,265426,641877,981085,453138,867241,51960,748905,987260,4865,320765,441437,427212,996942,248109,480327,148026,865490,469578,636799,775318,1003277,196580,743163,416209,801228,675700,524975,176233,75389,68819,178573,933969,495350,769560,401399,1021944,436374,893374,552219,595121,838727,346025,757799,939913,955760,1002277,703084,105764,429637,757846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]