SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39558 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39558 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18503,700387,440880,402634,751154,221486,144341,390306,985863,591214,5948,1018087,246468,1002594,709557,311808,666492,740506,586357,553259,868036,9037,919806,916379,673714,1020889,934162,471064,294799,552543,1002155,406680,217328,552546,794441,49183,277363,753063,469461,178133,362523,635108,730900,849852,369630,500950,413751,684510,837930,463140,219721,325104,437289,60740,634395,643005,728790,972886,201656,885305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39558 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39558 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]