SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003919s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503488 LIMIT 1 [ RunTime:0.001257s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503488 [ RunTime:0.003467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029070,513569,677254,718310,757991,583988,945126,78887,1006129,521461,623836,627796,727035,254205,311612,909290,684340,137407,428706,998687,1041650,756701,827857,170636,595465,81937,613430,749666,849296,920391,10151,147632,495023,331797,709328,869058,102354,1023365,903229,599969,173393,885793,565131,848488,253846,996981,797990,264323,738357,385248,993923,194895,648994,365245,353887,589776,994730,692701,834281,96812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503488 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503488 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]