SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401288 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401288 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475036,801812,293047,144203,929283,874407,299375,53899,34459,362193,6808,173369,206561,728335,849401,822852,98516,1007311,329493,817254,816125,312957,328789,502126,851834,699936,851951,514143,581507,802712,465830,35887,1011876,813635,881939,161837,645920,33174,387206,206931,1042594,396154,137242,890659,634366,807018,889454,503785,926384,770736,705292,307603,28081,261235,674960,677333,301326,906835,570192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002225s ]