SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200978 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200978 [ RunTime:0.004555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402452,345683,254269,674577,161375,255391,862162,388489,240889,43050,232176,774488,687434,375678,677719,100317,877606,805028,302293,637690,550191,238903,456781,1044142,898839,982866,324621,40811,375590,929940,900226,797356,99145,320826,315625,860238,327036,231026,856314,203262,573380,445045,625648,444563,309842,659142,635515,847736,341270,747432,97909,466655,426433,694875,93204,902523,779915,536587,685060,576166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001459s ]