SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301287 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301287 [ RunTime:0.002059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331962,127005,311546,320610,159509,336722,422620,262265,396757,586737,385466,569310,24250,736961,1014934,131654,474320,752744,685161,738802,739486,816579,360798,327580,476388,972715,257821,780162,721945,915100,777953,738442,358074,496646,987174,504253,624249,18237,625115,38289,772322,942965,906917,774229,783778,83369,606382,633972,316131,880461,251413,650422,748842,299883,205547,551581,775675,218177,779438,831609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301287 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301287 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]