SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331289 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331289 [ RunTime:0.007239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522034,864363,915725,594645,742003,109275,307488,215392,381224,793637,96462,986387,86801,834042,566700,642043,245104,305692,560973,161583,1026433,1005785,289588,271823,31414,1022293,529031,928428,795264,100451,1028250,430339,623221,959584,648108,380699,1045811,228029,568418,167973,222093,420830,921877,714517,770204,192684,938040,760429,502129,568110,926779,343986,903796,520100,895168,774243,842167,727463,179662,404779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]