SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547952 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547952 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332746,796924,674521,247533,534062,694480,541179,1031900,541697,577063,576487,622244,594468,658468,887333,331552,36117,343973,155687,37571,366021,495368,560771,1035298,5162,14892,381999,837733,660364,786140,523618,343974,1003866,1046204,769389,176514,696137,704882,982905,689194,259811,351169,475937,885143,1012363,598375,154229,241283,995908,539205,1020495,832059,465345,124198,595959,236697,446265,429684,233066,58067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]