SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506649 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506649 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277047,530853,322604,197280,315239,678592,216370,953123,254228,146269,714912,610350,110779,876566,647569,381902,552078,794830,527263,638933,208080,867882,412045,295523,988655,875356,863911,590970,859035,753504,995944,702634,300775,324677,289006,281018,704622,294324,315396,431026,319800,451334,204017,296482,172434,381320,1037888,572633,131985,922688,983111,957843,796931,479187,417082,964294,76418,592188,848876,249058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506649 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506649 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]