SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504062 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504062 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434206,802855,1038191,264325,1018169,452268,644313,626622,919460,277651,816437,945508,645462,126170,870897,1020508,342524,481366,893661,239293,659005,1030401,231526,698766,162019,593182,310729,878713,555930,638912,85180,456150,21132,239032,227150,126236,174908,30587,139877,634409,554429,654827,379146,517382,1043526,55672,374857,571342,278518,957768,444344,66435,210571,441929,1006862,527649,962143,152609,574280,703284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]