SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039298 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039298 [ RunTime:0.002618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418862,973830,1025641,968221,831673,997535,514739,17291,195835,21452,682039,557251,816328,547724,702614,372302,416081,49567,871473,951241,499380,664856,791965,15552,562332,239583,90873,511157,471884,682877,210233,931813,440750,295587,147485,89951,621720,13609,82211,952233,464467,161171,379432,746345,333955,191474,716985,825834,693818,118328,109672,749067,543205,775544,284654,187948,452309,587834,471462,369024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003894s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039298 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039298 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]