SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001691s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409435 LIMIT 1 [ RunTime:0.000726s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409435 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312742,637337,260830,976578,948601,231509,364077,995337,694756,685140,613900,650215,701986,859846,708377,798945,446801,674885,899129,984030,651816,57349,761832,438294,19526,470754,306841,692825,242061,229606,722909,483734,777775,620004,1047596,1010487,381843,20270,579395,346374,545057,382098,374986,365861,150502,739097,227703,712000,617257,375254,817997,286186,690655,861213,812649,684093,136418,316762,434977,844975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]