SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438524 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438524 [ RunTime:0.005232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116078,898531,543901,999114,125010,337456,558948,872823,741633,992914,124307,81957,779962,985125,399267,1022895,139095,895719,1015169,173029,1032899,1031486,614022,648776,264767,159928,666672,575592,815161,163440,88912,999113,1009785,270488,884424,59219,212763,104831,398014,217736,395767,1043264,564924,559842,278111,1003418,166276,54528,208367,956051,550398,927982,257893,649004,860325,459254,842823,812640,374664,547417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]