SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45111 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45111 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592058,155103,751064,199367,20518,532535,292099,303781,260166,545013,60,684700,103621,483855,1019896,973149,457478,730652,871795,603109,825194,288099,431367,477197,72579,943801,625368,294218,830411,502949,374691,712832,1023592,1989,367191,919340,498837,59285,523714,927791,494154,707965,706372,568970,84149,346462,797241,688479,532998,335042,109112,907648,514171,375143,496136,161463,168110,747472,581812,521644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]