SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581219 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581219 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315882,336055,322029,260328,122413,625623,833898,855952,802233,118422,428855,668081,744757,91802,382754,981442,25148,547842,702704,924217,142429,244780,718143,973800,88911,779742,272866,488145,376304,36771,467331,759759,178757,322997,1029102,435022,454481,204732,465449,690271,293467,987821,15935,948755,647488,536329,593471,429455,320353,468279,541330,556850,934847,122015,1042137,681039,48232,32539,117869,544960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]