SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5010 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5010 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150492,752794,156166,374144,96334,791876,851598,391074,442933,608905,609412,799493,474384,507106,336676,996601,950710,239703,737002,234854,40159,434572,742093,575051,966707,235513,355239,890160,396007,418557,418780,596939,705419,36956,227024,495598,730381,316172,904412,630150,720362,826243,421944,93082,234043,248987,426002,691151,589693,554176,190570,48557,1023108,355905,643002,486924,672539,997184,724256,791746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002739s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]