SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507526 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507526 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901250,898518,823450,657041,38193,955717,10668,298976,409414,893050,87908,830172,633307,179384,90552,469316,185802,1004583,453298,47183,548615,654264,888914,63861,742700,600871,856615,582032,903855,390796,202869,381414,655745,662424,779902,199810,94693,527669,370320,206009,72792,200950,809544,802519,950855,395087,710089,140992,533412,620951,20666,1005416,318495,783777,500381,888981,954485,228918,862973,758675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000909s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]