SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566080 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566080 [ RunTime:0.003008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94258,634416,185940,1038000,532538,343721,624511,446896,801575,209534,286195,802939,567500,624149,695361,281271,629536,751314,700856,960033,814947,452275,477562,39034,170646,804853,986633,675755,448789,902791,948668,493871,838172,25724,3430,746666,431281,291694,818115,107709,677962,95634,929249,659811,677819,287432,908787,634138,916087,885151,179967,643780,766395,582833,526057,605199,871803,194890,55477,593604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]