SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565027 LIMIT 1 [ RunTime:0.000593s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565027 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294460,334169,143875,608208,629308,71135,625953,869034,503118,77575,481322,270946,504694,10316,696548,269703,1008994,841967,938505,847690,955766,395245,985040,971978,584394,414370,648150,477016,346410,638854,893735,717040,90321,638521,200467,582944,1012874,1032816,480770,752760,848222,136061,309964,628714,207839,470531,50560,673331,769918,499424,363130,270537,890203,254980,338694,327449,984609,586881,284781,798620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]