SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509813 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509813 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355375,1014099,887812,451034,99825,845039,789136,792334,556090,138281,251002,323057,821670,37123,50174,448493,89027,34464,514303,391713,398511,797854,264052,191879,363534,147801,191716,221382,1004532,393030,114262,256863,884174,219472,351711,507825,783897,376818,280341,318919,618926,763092,956214,969436,310228,944905,313338,615838,1018089,491553,545079,527963,1019,41378,1001165,537459,924846,835804,775695,863309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]