SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002012s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110639 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110639 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863520,128204,45335,1020024,135927,11204,48667,406295,974092,887309,806248,742638,898346,404685,183286,471586,996356,883438,643036,458933,284025,307751,568733,151575,10587,338801,962781,269988,136956,396474,848091,131714,38000,531871,40687,657751,670131,578467,440585,961937,840788,650676,756293,984161,298557,307769,472368,104706,875680,567976,642109,188764,918173,914783,512956,136690,496645,246338,150391,482626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]