SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549364 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549364 [ RunTime:0.002652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39988,265231,115209,832528,127201,153770,656574,471189,958186,647274,850271,151929,808470,143766,32788,832877,797438,355533,297886,453097,634301,764966,964211,191824,869052,883771,569537,804171,200717,736425,266297,979235,486238,96455,179654,97706,840440,706728,798157,41751,12967,54755,164499,786519,742359,499041,85259,482570,731379,78819,544739,880799,823823,319360,303958,598730,118322,38940,668285,695283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]