SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420037 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420037 [ RunTime:0.003559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310485,845049,952738,501555,177050,125006,693811,248745,1015351,986540,769386,833328,544988,1020771,444763,442374,541224,636021,63535,330509,157049,196935,799075,1027249,576964,875170,341689,1039924,530324,243614,728198,693936,25924,30520,322230,379166,372667,197054,449572,700929,756788,876856,471099,965356,260465,991288,30245,982770,131773,190671,231625,292677,979539,573779,812776,353200,280594,16037,428413,150882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]