SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 907509 LIMIT 1 [ RunTime:0.000687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 907509 [ RunTime:0.002378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544271,438064,998851,338014,618196,241524,39171,557717,31609,942188,706528,641889,545825,106069,209040,170912,735290,500187,187805,778558,905195,652244,442209,433757,343049,451582,211024,674971,73043,482205,159786,878404,60150,984060,571823,30563,72969,326095,836923,186792,819011,155969,919714,62146,273148,1044428,1027182,433370,242243,38956,766418,279613,573430,913542,767991,940488,227450,307180,113483,175072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 907509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 907509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]