SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465907 LIMIT 1 [ RunTime:0.001206s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465907 [ RunTime:0.002187s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57691,891284,977239,505352,135416,347549,1004314,824907,21170,673491,1024390,582609,841799,193938,298944,13284,308789,421565,395113,62004,459476,568974,141740,143984,926224,693643,367571,517819,605284,348996,57808,897803,678183,520293,459249,621277,673901,284174,913506,1042390,722199,878922,293986,701183,828028,449511,558920,982337,715243,101514,462874,1011327,476275,424812,563626,269155,505759,246174,312702,35894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]