SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502543 LIMIT 1 [ RunTime:0.000572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502543 [ RunTime:0.002378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689768,930132,821303,266767,679342,444110,254306,808939,519308,764473,773676,366990,725436,237064,399289,100764,394962,629919,52325,380364,416450,870699,186264,937349,161518,767224,306239,21664,12026,696727,298967,423070,461615,815302,523328,121222,570179,216014,902260,338185,737267,330412,1014039,794082,874983,395869,457202,651969,513274,1017006,1025529,255247,590580,557681,1014731,727606,897948,258319,791795,56005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]