SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505800 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505800 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309934,171489,269276,884041,158851,639122,363285,332375,196096,34310,969057,866555,412722,922900,532144,893414,729393,347702,992965,937741,1028506,882378,773995,477042,26932,223760,200880,964582,110081,921644,968742,498194,624376,109673,939397,262772,965443,456797,176271,941176,913110,922689,852005,964365,665411,705194,62760,916585,12749,307675,617274,493711,506306,1017482,825564,773031,136304,872750,277622,545628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]