SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497540 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497540 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187815,725710,350633,292278,84557,705480,321859,251576,10907,518200,412639,76317,431547,236014,764430,934101,700634,1005320,671031,205323,924186,121050,399276,802265,467069,860728,579469,203092,807344,771800,315331,172532,287166,238000,417632,259314,11334,290328,276045,863298,788925,419720,197889,728934,667598,297526,278984,928230,497181,240330,575555,844779,374720,809190,304686,235906,891408,171608,638588,77520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]