SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008403 LIMIT 1 [ RunTime:0.001207s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008403 [ RunTime:0.001479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338361,489802,1011750,246877,674215,720301,547023,836025,512833,232975,1012150,406795,194669,203661,991286,1012299,116566,582117,293439,630870,16092,188985,645382,495594,293310,554441,1011120,257562,344864,1014876,1025929,758765,175283,870683,40176,1003829,945040,867600,941569,834768,584466,109087,229286,756542,955937,173076,741343,635895,892159,394845,933492,877938,798980,108090,211094,508125,393587,124083,565239,60869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001374s ]