SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339660 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339660 [ RunTime:0.002476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535700,259118,941682,450268,688745,845821,3846,81532,1040324,290792,569665,98152,668050,851691,21283,401024,258988,326418,858403,542528,548481,861292,228902,805532,648380,255911,52701,269855,127987,422153,139037,922763,713553,1019975,678006,717069,624930,867403,1015160,479444,228121,648066,155177,486134,651831,277991,945656,811743,163720,953770,377495,155985,983355,523402,261075,907710,152721,316300,246639,873222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]