SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492912 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492912 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135082,280120,1027797,533132,634157,609028,494425,1032841,918979,481213,244904,339228,20787,958338,196167,647719,1019504,394280,926518,654332,1019780,891500,837605,40913,943921,266812,319746,366936,881994,67373,233138,396196,221173,812797,65270,614080,962028,46579,580492,56363,61034,175994,272585,583441,794740,394540,481199,453715,710028,1029283,982824,622020,729965,676031,686589,163785,909129,561264,654455,869556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]