SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 127013 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 127013 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (688608,864749,26409,282933,470555,207263,977559,168972,517132,79056,261684,842470,156669,701440,842152,1006820,92138,119548,74215,951582,460050,786017,22614,947954,441067,257606,334636,13057,366133,339888,122229,751413,50003,358683,162957,594470,175508,81987,589422,509930,849466,380713,266070,374884,185583,934812,153323,78577,340391,917517,736738,965232,880832,848278,843306,634389,403203,669164,970505,601618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 127013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 127013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]