SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561088 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561088 [ RunTime:0.004466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323384,497118,979067,26036,577444,742430,681508,586942,943665,113229,714382,131994,739549,791042,16351,629131,52040,398659,827461,614186,73057,844661,524223,658574,89278,966917,833541,120351,378825,837206,502715,677250,904540,314241,201372,675253,512825,877669,267154,636017,202344,124423,191599,164741,35189,453929,133004,612623,980123,689,169738,598240,650208,872469,1030062,824024,806983,154142,679376,537321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002823s ]