SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023390 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023390 [ RunTime:0.002295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706382,33264,853308,299636,405523,26127,715504,944146,411940,211231,556543,681218,996467,810707,537484,624818,714217,144158,950565,331947,415847,443248,691815,19223,334680,303075,954281,644480,870960,631347,83299,714797,481604,598020,246585,545444,733122,388905,470638,367758,196782,361445,421350,5071,74941,680399,245401,419196,520642,709252,865598,111485,185886,460580,68973,158219,969596,788861,639003,845004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]